Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# REMBYTES

The REMBYTES function removes one or more bytes from a text expression and returns the value that remains.

Return Value

TEXT

Syntax

REMBYTES(text-expression start [length])

Arguments

text-expression

  The `TEXT` expression from which REMBYTES removes bytes. When the characters to be removed from text-expression contain embedded line breaks, these breaks are also removed. Other line breaks are preserved. Removed line breaks are not counted toward the total number of characters removed.

  Tip: When you must use this function on NTEXT values, use the CONVERT or TO_CHAR function to convert the NTEXT value to TEXT.

start

  An `INTEGER` that represents the character position at which to begin removing characters. The position of the first character in text-expression is `1`. When the value of start is greater than the length of text-expression, REMBYTES simply returns text-expression.

length

  An `INTEGER` that represents the number of characters to be removed. When length is not specified, only the character at start is removed.

Examples

Example 20-16 Using REMBYTES to Remove a Substring

This example shows how to remove the substring `there` from the text value `hellotherejoe`.

The statement

    SHOW REMBYTES('hellotherejoe', 6, 5)

produces the following output.

    hellojoe